CREATE TABLE [dbo].[Rpt_BadgeTbl]
(
[ORDER_NUMBER] [float] NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_ORDER_NUMBER] DEFAULT ((0)),
[BADGE_TYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_BADGE_TYPE] DEFAULT (''),
[FULL_NAME] [varchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_FULL_NAME] DEFAULT (''),
[FIRST_NAME] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MIDDLE_NAME] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_MIDDLE_NAME] DEFAULT (''),
[LAST_NAME] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_LAST_NAME] DEFAULT (''),
[PREFIX] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Rpt_BadgeTbl_PREFIX] DEFAULT (''),
[SUFFIX] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_SUFFIX] DEFAULT (''),
[DESIGNATION] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_DESIGNATION] DEFAULT (''),
[INFORMAL] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TITLE] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_TITLE] DEFAULT (''),
[COMPANY] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_COMPANY] DEFAULT (''),
[CITY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_CITY] DEFAULT (''),
[STATE_PROVINCE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_STATE_PROVINCE] DEFAULT (''),
[ZIP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_ZIP] DEFAULT (''),
[DELEGATE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_DELEGATE] DEFAULT (''),
[REGISTRANT_CLASS] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_REGISTRANT_CLASS] DEFAULT (''),
[REG_TYPE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_REG_TYPE] DEFAULT (''),
[BADGE_NUMBER] [int] NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_BADGE_NUMBER] DEFAULT ((0)),
[COUNTRY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserID_Date] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_BadgeTbl_UserID_Date] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iRpt_BadgeTblTICKET_NUMBER] ON [dbo].[Rpt_BadgeTbl] ([BADGE_NUMBER]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRpt_BadgeTblORDER_NUMBER] ON [dbo].[Rpt_BadgeTbl] ([ORDER_NUMBER]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRpt_BadgeTblUserID_Date] ON [dbo].[Rpt_BadgeTbl] ([UserID_Date]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Rpt_BadgeTbl] TO [IMIS]
GRANT SELECT ON  [dbo].[Rpt_BadgeTbl] TO [IMIS]
GRANT INSERT ON  [dbo].[Rpt_BadgeTbl] TO [IMIS]
GRANT DELETE ON  [dbo].[Rpt_BadgeTbl] TO [IMIS]
GRANT UPDATE ON  [dbo].[Rpt_BadgeTbl] TO [IMIS]
GO